Show: Today's Messages :: Unanswered Messages :: Polls :: Message Navigator
49 Search Results Found
1 Forum: Business Intelligence «» Posted on: Sat, 23 May 2020 03:12 «» By: oluranti
Re:Invalid Service name in RCU installation for OBIEE 12c
…Hi, I want to install OBIEE 12c and practice with it on my laptop. I have successfully installed the following: Oracle Database 12c (I have done the data configuration installation) Weblogic BI plaform but got stuck on RCU step 3 of 8 (picture …
2 Forum: RAC & Failsafe «» Posted on: Thu, 17 May 2018 10:50 «» By: sarahLian
Root.sh failed: ORA-39510: CRS error performing start on instance '+ASM1' on '+ASM'
…Hello, I have some issues with the installation of Oracle RAC 12.2 on RHEL 7. Could you please help me with this issue ? Thanks in advance. The root.sh failed with the following error: ORA-39510: CRS error performing start on instance '+ASM1' …
3 Forum: Server Administration «» Posted on: Wed, 06 December 2017 21:08 «» By: lzfhope
Re: global temporay table does not work!
…Today,i found that init parameter "temp_undo_enabled" is set to true,which is the only changed parameter recently! Have a try,restored it to "false"! as a result,global temporary table(on commit preserve) could still hold data …
4 Forum: SQL & PL/SQL «» Posted on: Wed, 29 November 2017 05:12 «» By: dba4oracle
Re: trigger impacting performance
…Hi, Below is DDL of master table and trigger source temp(staging) table is same as master table but no constraints,index,partition and no trigger attached to it CREATE TABLE "schema1"."Master1" ( "…
5 Forum: SQL & PL/SQL «» Posted on: Sun, 27 August 2017 13:00 «» By: rkrishna
Re: Bulk Inserts with CLOB column Slower in Oracle 12c than Oracle 11g
…are in the verge of making the decision to upgrade to 12c, and this extremely slow performance on Inserts is a major blocker. The expectation is that 12c should be at least as fast as 11g, if not better. I am looking for any suggestion on whether we need …
6 Forum: Linux «» Posted on: Tue, 23 August 2016 02:47 «» By: trantuananh24hg
Tips for Installation 11gr2 on RHEL6
…ago, I finished installation the 11gr2 on RHEL6, and there are some tips here: 1. Install the requirement pacakges [root@spsdev ~]#yum install local compat-libstdc++-33* [root@spsdev ~]#yum install local libaio-devel-0.* [root@spsdev ~]#yum …
7 Forum: Marketplace «» Posted on: Mon, 22 August 2016 10:14 «» By: Michel Cadot
Re: McDP: like expdp/impdp Data Pump programs and much more
… DDL command In the same vein than the previous command, CONTENT, McDP allows you to get the DDL of all or part of a database, with the transformation you want, using the DDL command. Its syntax is: McDP [<logon>] { -ddl | --ddl } [<…
8 Forum: SQL & PL/SQL «» Posted on: Tue, 17 May 2016 09:32 «» By: mjm22
MEMBER OF condition across DB Link
…Hi, I have come across a scenario that I am struggling to understand... I am trying to insert to a table a subset of values selected form another table on a remote database. The selection is controlled via a MEMBER OF condition that limits the …
9 Forum: Server Administration «» Posted on: Mon, 30 September 2013 00:33 «» By: ishika_20
ORA-30967: operation directly on the Path Table (during CSSCAN process)
…All, While doing scanning of character set, error occurred in between. Kindly assist me to solve the problem. Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production With the Partitioning, OLAP, Data Mining and Real Application …
10 Forum: Performance Tuning «» Posted on: Thu, 11 April 2013 10:52 «» By: Michel Cadot
Re: How to find out session consuming high resource in the past?
…Ah! you were talking about the columns... I thought the view... sorry. They indeed are there only in 11g: mikb2=MIKB2/ILLUVATAR MICHEL> desc DBA_HIST_ACTIVE_SESS_HISTORY Name Null? Type…
11 Forum: Application Express, ORDS & MOD_PLSQL «» Posted on: Sun, 24 February 2013 07:10 «» By: BLROracle
create remote file with util_file
…Hello, i´am a newon pl/sql and i have question about util_file. My environment: Database is installed on some server, which i have no access. I have to export some data from this database. 1.At first, i have to create some csv and xml files. …
12 Forum: Performance Tuning «» Posted on: Wed, 17 October 2012 10:00 «» By: segan1415
Re: NOLOGGING in Oracle 11gr2
…seems from the new AWRRPT, I am now swapping log files every fifteen minutes (since there is only 1 switch, I ran a second awrrpt from 801-803 and there was 2 switches - confirming this) AWRRPT 801-802 (50M REDO LOG FILES) Toggle Spoiler WORKLOAD…
13 Forum: Performance Tuning «» Posted on: Wed, 17 October 2012 02:17 «» By: Roachcoach
Re: NOLOGGING in Oracle 11gr2
…those who cannot download, contents in the spoiler section to save a wall of text Toggle Spoiler WORKLOAD REPOSITORY report for DB Name DB Id Instance Inst Num Startup Time Release RAC…
14 Forum: Windows «» Posted on: Wed, 28 March 2012 02:36 «» By: ranamirfan
Re: Unable to install oracle 11gR2 on Windows 7 Professional.
…file. [main] [ 2012-03-28 10:23:38.047 AST ] [HAUtils.getHASHome:631] Oracle home from system properties: C:\oracle11g\hoitdevweb3\product\11.2.0\dbhome_1 [main] [ 2012-03-28 10:23:38.047 AST ] [HAUtils.getCRSHome:588] Getting configured CRS/HAS …
15 Forum: SQL & PL/SQL «» Posted on: Sat, 11 February 2012 02:04 «» By: aallan
Re: Create HTML table problem in email
…Michel for reply, this is my code: Create Or Replace Procedure Sale.Html_Email_With_Attach( P_To In Varchar2, P_Cc In Varchar2 Default Null, P_Bcc In Varchar2 Default Null, P_From In …
16 Forum: SQL & PL/SQL «» Posted on: Mon, 06 February 2012 02:03 «» By: aallan
Create HTML table problem in email
…Dears; I used this procedure to send html email: Create Or Replace Procedure Sale.Html_Email( P_To In Varchar2, P_Cc In Varchar2 Default Null, P_Bcc In Varchar2 Default Null, P_From In …
17 Forum: SQL & PL/SQL «» Posted on: Thu, 13 October 2011 06:05 «» By: muktha_22
Re: Problem in DBMS_FILE_TRANSFER.PUT_FILE
…Michel/Jhon, Still I am not able understand the issue. SQL> create database link link8 connect to bkpusr identified by Issl#2010 using '10GTEST'; Database link created. SQL> select * from tab@link8; TNAME …
18 Forum: Performance Tuning «» Posted on: Fri, 02 September 2011 07:08 «» By: msol25
Re: how we can match variable sga using v$sga and v$sgastat views
…Michel, Please find details : SQL> select * from v$sga; NAME VALUE -------------------- ---------- Fixed Size…
19 Forum: Linux «» Posted on: Mon, 02 May 2011 13:10 «» By: juniorpeardba
Re: SQL Plus no access
…Hi, log file from installation more installActions2011-04-28_02-48-23PM.log Using paramFile: /opt/oracle/Disk1/install/oraparam.ini Checking Temp space: must be greater than 80 MB. Actual 2693 MB Passed Checking swap space: must be greater …
20 Forum: Server Administration «» Posted on: Mon, 02 May 2011 06:47 «» By: juniorpeardba
Re: incorrect version of oracle
…Hello, here are the results of the log file more installActions2011-04-28_02-48-23PM.log Using paramFile: /opt/oracle/Disk1/install/oraparam.ini Checking Temp space: must be greater than 80 MB. Actual 2693 MB Passed Checking swap space…
21 Forum: Enterprise Manager «» Posted on: Mon, 06 September 2010 09:07 «» By: dbanukesh
OEM11g Management Agent deploy errors on Oracle 10g R2 4 node RAC
…All, I have been facing issues deplyong OEM 11g agent on Oracle 10g Target databases. I have installed OEM Agent 11g which is functioning perfectly. Now i am trying to deploy management agent 11g on Target databases which are a Oracle 10g RAC system …
22 Forum: Oracle Fusion Apps & E-Business Suite «» Posted on: Tue, 17 August 2010 15:49 «» By: davholla
Re: Install Oracle E-Business Suite new error
…is the log file Oracle Applications Rapid Install Wizard Install log >> Using Rapid Wizard Version : 12.1.1.9 >> Install session started : Tue Aug 17 21:41:47 BST 2010 >> Rapid Wizard source location : /tmp/…
23 Forum: Server Administration «» Posted on: Thu, 15 July 2010 00:00 «» By: maniatniit
Re: ORA-00214:
…file d:\oracle\product\10.2.0/admin/orcl/bdump\alert_orcl.log Wed Jun 09 17:19:45 2010 ORACLE V10.2.0.1.0 - Production vsnsta=0 vsnsql=14 vsnxtr=3 Windows XP Version V5.1 Service Pack 2 CPU : 2 - type 586 Process Affinity : …
24 Forum: Server Administration «» Posted on: Thu, 10 June 2010 23:10 «» By: reym21
db creation ctl error
…Pls. help me... I need this dB by Saturday! Thank you in advanced. It's been 2 days from now that I'm bugging with this kind of error in my manual dB creation. I used DBCA first but we had a default directory settings, that's why I resorted to create the…
25 Forum: Unix «» Posted on: Wed, 19 May 2010 12:38 «» By: medamadhu1
Re: unix shell script
…Rajendhran, Thanks for your reply.It's actually a long task which i have broken into two parts.I was able to write a script for the 1st part but i need some help with the 2nd part.Please have a look at the whole task and let me know if u have any …
26 Forum: Weblogic & Application Server «» Posted on: Thu, 28 January 2010 13:11 «» By: her_fedo
OracleAS - Report Server
…Hi, I'm runnig Application Server on my computer, starting OC4J and namingservice, I could run my forms the issue is with the reports, show me: Unable to connect to report server: rep_2kgpkc1 I have rep_2kgpkc1.conf file and modified rwnetwork.conf. I …
27 Forum: SQL & PL/SQL «» Posted on: Sat, 02 January 2010 23:07 «» By: patjose
Re: Parallel DML is not working.
…mount point is on EMC Clarion Disk Array and RAID Type is RAID1/0. So lun is mirrored and striped. This particular lun has around 60 disks each with 73GB. So undo, redo files, temp and datafiles are on this lun and hence on the same mount point. …
28 Forum: Replication «» Posted on: Mon, 22 September 2008 02:42 «» By: PayoRanger
Add_Master_Database fails
…Everybody, thanks in advance for your help. I'm trying to configure and run replication. I have two PC's running as Oracle servers, having both of them the same configuration: Windows XP Pro Oracle 11g Enterprise Edition First server is …
29 Forum: Performance Tuning «» Posted on: Mon, 01 October 2007 15:43 «» By: Frank Naude
Re: Tuning query (insert using select)
I would load the remote tables into local temp tables first, then join them. Also, consider creating indexes on the local temp tables before the final join phase.
30 Forum: Replication «» Posted on: Fri, 27 April 2007 13:08 «» By: thierno
Multimaster Replication
…All, I'm not good in english but I will try to decribe my problem. I want to do replication between to database Oracle 10.0.2.0.1 There are scripts given to deal with. I verify that in the both databases parameters are correct. I execute this script at…
31 Forum: SQL & PL/SQL «» Posted on: Fri, 23 March 2007 13:41 «» By: Michel Cadot
Re: Script prob after changing from Oracle 9i to 10g R2 ORA-02021 ORA-30041
… You cannot execute a DDL on a remote database, nobody can, this is a fact. However you can call a remote procedure that executes a DDL, for instance dbms_utility.exec_ddl_statement. There is no quota on temp tablespace, they are useless, you don't …
32 Forum: SQL & PL/SQL «» Posted on: Fri, 23 March 2007 12:20 «» By: t.summerfield
Script prob after changing from Oracle 9i to 10g R2 ORA-02021 ORA-30041
… I have recently formatted and setup one of the servers at work (windows server 2003) and have installed Oracle 10g R2 on it. It previously had Oracle 9i My role in this is as the DBA and as such I have very little SQL experience! I have a …
33 Forum: Performance Tuning «» Posted on: Tue, 06 March 2007 20:18 «» By: Tom_webex
How to tuning our oracle product server?
… We have a product server,it can work normal daily(speed can ok),but when we deal with large mount of data(insert,update,delete),the deal speed is very slow,I have the statspack report,pls tell me how to tuning? THANKS! STATSPACK report for …
34 Forum: SQL & PL/SQL «» Posted on: Wed, 12 July 2006 21:50 «» By: rleishman
Re: How to compare two huge tables in Oracle?
…@JRowbottoms advice is solid gold. Use it. It performs almost exactly the same algorithm as the MINUS SQL (internally), but it will perform the sort of the remote table on the remote database! Not on the local database. The problem with the MINUS …
35 Forum: Networking and Gateways «» Posted on: Mon, 20 March 2006 17:42 «» By: nmacdannald
Re: Connecting to Remote Server
…links. Okay, here is the deal. I just spent two days reading about something that a person can explain in two minutes. 1) Make sure your tnsnames.ora have the same correct entries on both local and remote databases. then lsnrctl reload The …
36 Forum: Networking and Gateways «» Posted on: Mon, 20 March 2006 17:33 «» By: nmacdannald
Database links explained...
…links. Okay, here is the deal. I just spent two days reading about something that a person can explain in two minutes. 1) Make sure your tnsnames.ora have the same correct entries on both local and remote databases. then lsnrctl reload The …
37 Forum: Networking and Gateways «» Posted on: Mon, 20 March 2006 17:28 «» By: nmacdannald
How to create a database link
…links. Okay, here is the deal. I just spent two days reading about something that a person can explain in two minutes. Make sure your tnsnames.ora have the same correct entries. then lsnrctl reload create a public database link on the local …
38 Forum: SQL & PL/SQL «» Posted on: Wed, 15 February 2006 01:28 «» By: sxramas
Database Link
…have a database link STG_DEV in DEV environment which connects to TEMP instance. create database link STG_DEV connect to STG identified by stg using 'TEMP'; TEMP database is up and running fine.Iam able to connect it.Still I get this error. When I …
39 Forum: SQL & PL/SQL «» Posted on: Thu, 10 November 2005 11:08 «» By: ebegoli
Copying BLOB over DB_LINK
…Hi, I am trying to copy a blob over the db_link. Just doing a plain read gives : ORA-22922 Can not remotely access LOB locator. Suggestion by Tom Kyte is to create temporary global table, and copy the blob over into it. insert into temp …
40 Forum: SQL & PL/SQL «» Posted on: Thu, 10 March 2005 05:42 «» By: Ken Jones
Re: Cursor Loop
… v_rc sys_refcursor; v_user dba_users%rowtype; v_node orcladmin.node_tns.node_tns%type; begin for rec_node in (select node_tns from orcladmin.node_tns where dbname like 'GM%' and dbname not in ('GMDU7','GMPA')) loop open v_rc for '…
Pages (2): [1  2    »]

Current Time: Mon Jul 08 16:06:58 CDT 2024